Select DISTINCT(yr) from (select year(issue_date) as yr, issue_date from printsize_master,stamps where issue_date!='' and printsize_master.printsize_code=stamps.printsize_code and printsize_master.printsize='2.56 x 2.5' and stamps.serial_no='0611' order by issue_date) t